/*********************************************************************************
 * File Name: MessageTable.java
 * Package Name: com.sensorfriendly.provider.impl
 * 
 * Purpose:
 * A class the defines the schema of the Message Table
 *  
 *********************************************************************************/
package com.sensorfriendly.provider.impl;

import android.net.Uri;

import com.sensorfriendly.provider.TableSchema;

public class MessageTable extends TableSchema{
	
	
	private static final String TABLE_NAME = "sensor_friendly_message";

	// Base MIME type for the entity table.
	private static final String TABLE_TYPE = "vnd.en.sensor_friendly_message";

	public static final Uri CONTENT_URI = Uri.parse("content://"
			+ SensorFriendlyDBSchema.AUTHORITY + "/sensor_friendly_message");
	
	public static final String SORT_ORDER = "time_posted ASC";

	public static final String MESSAGE_CONTENT = "message_content";
	public static final String AUDIO_FILE_NAME = "audio_file_name";
	public static final String MESSAGE_IMAGE_NAME = "messsage_image_name";
	public static final String PARENT_SCENARIO_NAME = "parent_scenario_name";
	public static final String TIME_POSTED ="time_posted";
	
	
	private static final String[][] FIELDS = {{MESSAGE_CONTENT, "TEXT"}, {AUDIO_FILE_NAME, "TEXT"},
		{PARENT_SCENARIO_NAME, "TEXT"}, {MESSAGE_IMAGE_NAME, "TEXT"}, {TIME_POSTED, "INTEGER"}};
	
	protected MessageTable() {
		super(TABLE_NAME, TABLE_TYPE, CONTENT_URI, SORT_ORDER, FIELDS);
	}

}
